Create KPI 's and YOY Arrow 13
Step 1: Create Accident Per Day KPI
1. Double
click on the Card Icon on the visualization bar.
2. Card
visual will display on the report
3. Drag
and drop the "Accident Per Day " column from the DUI_Fatalities table
4. Configure the Format Accident Per Day KPI
a.
Click
General Tab:
·
X-
Position 0
·
Y
Position: 216
·
Width:
180
·
Height:
100
·
Categories:
Off
·
Font
Family: DIN
·
Background:
White (FFFFF)
·
Transparency:
15%
d. Boarder ON
· Boarder Color: White, 10% darker
Follow the gif below to create Accident Per Day KPI
Step 2: Create % Fatalities KPI
1.
Repeat
Step 1 (1 to 3 steps) to create % Fatalities KPI.
2. Configure the Format %Fatalities
a.
Click General Tab:
·
X- Position 0
·
Y Position:
213
·
Width: 180
·
Height: 107
·
Categories: Off
·
Font
Family: DIN Background: White (FFFFF)
·
Transparency:
15%
·
Boarder
ON
·
Boarder Color: Color: White, 10%
darker
Step 3: Create YOY KPI
1. Double click on the Card icon on the visualization bar
2. Card
visual will display on the report
3. Drag and drop the "YOY " column from the DUI_Fatalities table
4. Configure the Format YOY KPI
a. Click General Tab:
· X- Position 0
· Y Position: 320
· Width: 180
· Height: 110
· Categories: Off
b. Data Label:
· Color: Click (fx)
· Color formatted by: Select “Color Scale”
· Based on Field: Select “YOY”
· Minimum Custom color: 0B9A0E
· Custom: 0
· Maximum Custom color: EB5559
· Custom: 0
· Text size: 30
· Font Family: Tahoma
c. Title: ON
· Type: “YOY”
· Font color: Black
· Background:
· Color: ACDOE7
· Text Size: 17
· Font Family: DIN
· Background: White (FFFFF)
· Transparency: 15%
d. Boarder ON
· Boarder Color: White, 10% darker
Follow the gif below to create YOY KPI
Step 4: Create YOY KPI Arrow
1. Double
click on the Card Icon on the visualization bar.
2. Card
visual will display on the report
3. Drag
and drop the "Arrow YOY" column from the DUI_Fatalities
4. Configure the Format YOY KPI Arrow
Click on the Format icon on the visualization bar
a. Click General Tab:
·
X-
Position 0
·
Y
Position: 347
·
Width:
39
·
Height:
76
·
Categories:
Off
· Color: Click (fx)
·
Color
format by: Select “Field Value” from the list
·
Based
on Field: Select from the list DUI _Fatalities table “Color Arrow YOY” Column
·
Background:
ACD0E7
·
Transparency:
96%
c. Boarder OFF
Follow the gif below to create YOY KPI Arrow
To learn more about how to create KPI Cards and Indicators in Power BI, click the link below.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi